﻿CREATE PROCEDURE [dbo].[sp_public_getProgression]
AS
SELECT Game_Name, Game_Id FROM Games WHERE EXISTS (SELECT Raid_Id FROM Progress_Raids WHERE Games.Game_Id = Raid_Game AND Raid_Active = 'True');
SELECT Realm_Id, Realm_Name, Realm_Game FROM Realms WHERE EXISTS (SELECT Raid_Id FROM Progress_Raids WHERE Realms.Realm_Id = Raid_Realm AND Raid_Active = 'True');
SELECT Raid_Id, Raid_Name, Raid_Realm FROM Progress_Raids WHERE EXISTS (SELECT Boss_Id FROM Progress_Bosses WHERE Progress_Raids.Raid_Id = Boss_Raid AND Boss_Active = 'true');
SELECT Boss_Id, Boss_Name, Boss_Raid, Boss_Cleared FROM Progress_Bosses WHERE EXISTS (SELECT Raid_Id FROM Progress_Raids WHERE Progress_Raids.Raid_Id = Boss_Raid AND Boss_Active = 'true');
RETURN 0